Skip to main content
This forum is closed to new posts and responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum

  

PreviousPrevious NextNext

RE: Selecting a date from Combobox
~Mario Lopkistergon 15.Jan.04 07:19 PM a Web browser
Domino Designer 6.0.3 All Platforms


what style of the combobox did you have? The calendar date control?

What you want is possible. If the user is going to input the field as text, then you have to convert the field to be a date. Next then calculate what is the next Friday date?

For example:
tempvariable := @TexttoTime(<textfieldname>);
tempweekday := @Weekday(tempvariable);
tempnextfriday :=@if(tempweekday=7;@Adjust(tempvariable;0;0;+6;0;0;0);@Adjust(tempvariable;0;0;(6-tempweekday);0;0;0));

The formula language for tempnextfriday should be the date value computed basd on the name of the text fieldname. To wit, <textfieldname> needs to be replace with the actual name of the field. This formula could be placed into a computed date field as well.

HTH -- Cheers




Selecting a date from Combobox (~Ned Nonniplop 15.Jan.04)
. . RE: Selecting a date from Combobox (~Mario Lopkiste... 15.Jan.04)
. . . . RE: Selecting a date from Combobox (~Ned Nonniplop 15.Jan.04)
. . . . . . Just compute 2 fields and use @repl... (~Dan Elhipister... 15.Jan.04)
. . . . . . . . RE: Just compute 2 fields and use @... (~Ned Nonniplop 15.Jan.04)
. . . . . . . . . . Sorry, did not have enough parens..... (~Dan Elhipister... 15.Jan.04)
. . Sure this can be computed... (~Dan Elhipister... 15.Jan.04)

Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS